<?php
 session_start();
 include("include/session.php");
 include("include/common.php");
 include("include/db.php");
 
 if(isset($_REQUEST) && $_REQUEST['submit'] != ''){
 	
	$oldPassword 		= mysql_real_escape_string($_REQUEST['old_password']); 
	$newPassword		= mysql_real_escape_string($_REQUEST['new_password']);
	
	$sqlPassword 		= mysql_query("SELECT * FROM software_admin WHERE admin_password  = '".$oldPassword."'");
	$resPassword 		= mysql_fetch_array($sqlPassword);
	if($resPassword["admin_id"] > 0){
		$updatePassword  = "UPDATE software_admin SET admin_password  = '".$newPassword."' WHERE  admin_password  = '".$oldPassword."'";	
		if(mysql_query($updatePassword))
			header("location:change_password.php?msg=1");
		else
			header("location:change_password.php?msg=2");
	}

	exit();		
 }

 ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?=TITLE_WEBSITE?></title>
<link href="css/c_energy.css" rel="stylesheet" type="text/css" />
<link href="css/logo.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/datepicker.css" type="text/css" />
<link rel="stylesheet" media="screen" type="text/css" href="css/layout.css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/datepicker.js"></script>
<script type="text/javascript" src="js/eye.js"></script>
<script type="text/javascript" src="js/utils.js"></script>
<script type="text/javascript" src="js/layout.js?ver=1.0.2"></script>
<script type="text/javascript">
</script>
<style type="text/css">
<!--
.style4 {
	font-size: 22px;
	font-weight: bold;
}
.style6 {color: #999999}
-->
</style>
</head>
<script >
$('#inputDate').DatePicker({
	format:'m/d/Y',
	date: $('#inputDate').val(),
	current: $('#inputDate').val(),
	starts: 1,
	position: 'r',
	onBeforeShow: function(){
		$('#inputDate').DatePickerSetDate($('#inputDate').val(), true);
	},
	onChange: function(formated, dates){
		$('#inputDate').val(formated);
		if ($('#closeOnSelect input').attr('checked')) {
			$('#inputDate').DatePickerHide();
		}
	}
});
function validation(){
	
	var message = '';
	
	
	if(document.getElementById("old_password").value == ""){
		message += 'Please enter your old password\n';
	}
	if(document.getElementById("new_password").value == ""){
		message += 'Please enter your new password\n';
	}
	if(document.getElementById("confirm_password").value == ""){
		message += 'Please enter your confirm password\n';
	}
	if(document.getElementById("confirm_password").value != document.getElementById("new_password").value ){
		message += 'Please enter same password in both confirm and new password options';
	}
	
	if(message != ""){
		alert(message);
		return false;
	}
	
	
}
</script>
<body>

    <table width="990" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
        <td colspan="3" align="left" valign="top" ><? require("header.php");?></td>
</tr>
  <tr>
    <td align="center" >
	<table width="99%" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3" align="center" valign="top">&nbsp;</td>
      </tr>
       <tr bgcolor="#FAFAFA">
        <td colspan="0" align="left" valign="top" >
		   <table width="96%" cellspacing="0" cellpadding="0">
		    <tr>
		      <td width="2%" align="left" valign="top" style="padding-left:15px" ><? require("left.php");?></td>
		      <td width="94%"  valign="top" style="padding-left:15px" >
			  <form name="signform" action="" method="post" enctype="multipart/form-data" id="signform" onsubmit="return validation();" >
			    <table id="signInTbl" width="719" cellspacing="0" cellpadding="0" style="border:solid #cccccc 1px">
                  <tr>
                    <td colspan="2" align="left" bgcolor="#373737" class="loc_search_found_term"  style="border-bottom:solid #cccccc 1px">Change Password</td>
                  </tr>
                  <?php
                  	if($_REQUEST['msg'] == 1)
					{
				  ?>
                  <tr style="background: #D5FFD5 " height="25">
                 	<td colspan="2"><div align="left" class="successMsg" id="err_site" style="display:block">
                       &nbsp; <strong><?=($_REQUEST['msg'] == 1 ? 'Password changed successfully' : 'Sorry,password not inserted successfuly.')?></strong>
                    </div></td>
                  </tr>
                  <?php
                  	}elseif($_REQUEST['msg'] == 2){
				  ?>
                  <tr style="background: #FFE9E9 " height="25">
                 	<td colspan="2"><div align="left" class="ErrorMsg" id="err_site" style="display:block">
                       &nbsp; <strong><?=($_REQUEST['msg'] == 1 ? 'Password changedsuccessfully' : 'Sorry,record does not inserted successfuly.')?></strong>
                    </div></td>
                  </tr>	
				  <?php		
					}
				  ?>
                 <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Old Password</td>
                    <td width="466" align="left"><input  style="width:220px" name="old_password" id="old_password" type="password" class="Box" maxlength="35"  value="<?=$_REQUEST['old_password']?>" /></td>
                </tr>
                <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">New Password</td>
                    <td width="466" align="left"><input  style="width:220px" name="new_password" id="new_password" type="password" class="Box" maxlength="35"  value="<?=$_REQUEST['new_password']?>" /></td>
                </tr> 
                 <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Confirm Password</td>
                    <td width="466" align="left">
                      <input  style="width:220px" name="confirm_password" id="confirm_password" type="password" class="Box" maxlength="35"  value="<?=$_REQUEST['confirm_password']?>" />                    </td>
                </tr>
       
                   <tr  height="30">
                     <td width="249"  style="padding-left:15px" colspan="2" align="center"><input class="cls_button" type="submit" id="submit" name="submit" value="Submit"  /></td>
                   </tr>
                </table>
			    <ul class="site_nav_menu_buttons">
			      <li class="no_menu_li"><span><a href="main.php">&nbsp;Back to Main </a></span></li>
			      </ul>
			    <p>&nbsp;</p>
			  </form>			  </td>
            </tr>
	        </table></td>
        </tr>
      <tr bgcolor="#FAFAFA">
        <td width="800" align="center" valign="top">&nbsp;</td>
        <td width="100" colspan="2">&nbsp;</td>
      </tr>
	    <tr bgcolor="#FAFAFA">
        <td width="800" align="center" valign="top">&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

